﻿/****************************************************************************************************
 ** Name:        fkException_Severity
 ** Description: Relationship between the Exception and Severity tables.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

ALTER TABLE dbo.Exception
            ADD CONSTRAINT fkException_Severity
                           FOREIGN KEY (SeverityID)
                           REFERENCES dbo.Severity(ID)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Relationship between the Exception and Severity tables.', 'SCHEMA', N'dbo', 'TABLE', N'Exception', 'CONSTRAINT', 'fkException_Severity'
GO